Dataset statistics
| Number of variables | 27 |
|---|---|
| Number of observations | 767 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 161.9 KiB |
| Average record size in memory | 216.2 B |
Variable types
| NUM | 20 |
|---|---|
| CAT | 7 |
name has a high cardinality: 722 distinct values | High cardinality |
state has a high cardinality: 51 distinct values | High cardinality |
saifi_nomed has a high cardinality: 542 distinct values | High cardinality |
caidi_nomed has a high cardinality: 704 distinct values | High cardinality |
ba has a high cardinality: 51 distinct values | High cardinality |
total_cust is highly correlated with total_mwh and 1 other fields | High correlation |
total_mwh is highly correlated with total_cust | High correlation |
circuits is highly correlated with total_cust | High correlation |
nm_mwh is highly correlated with pv_mwh and 1 other fields | High correlation |
pv_mwh is highly correlated with nm_mwh | High correlation |
wind_mwh is highly correlated with nm_mwh and 1 other fields | High correlation |
wind_pct is highly correlated with wind_mwh | High correlation |
nm_pct is highly correlated with pv_pct | High correlation |
pv_pct is highly correlated with nm_pct | High correlation |
pv_mwh is highly skewed (γ1 = 21.71589745) | Skewed |
wind_mwh is highly skewed (γ1 = 25.81232179) | Skewed |
nm_mwh is highly skewed (γ1 = 22.41508526) | Skewed |
dem_res_mwh is highly skewed (γ1 = 26.53946767) | Skewed |
wind_pct is highly skewed (γ1 = 22.52253849) | Skewed |
name is uniformly distributed | Uniform |
total_mwh has unique values | Unique |
voltage has 473 (61.7%) zeros | Zeros |
gen_mwh has 569 (74.2%) zeros | Zeros |
purchase_mwh has 85 (11.1%) zeros | Zeros |
pv_mwh has 507 (66.1%) zeros | Zeros |
wind_mwh has 663 (86.4%) zeros | Zeros |
nm_mwh has 503 (65.6%) zeros | Zeros |
ee_mwh has 467 (60.9%) zeros | Zeros |
dem_res_customers has 536 (69.9%) zeros | Zeros |
dem_res_mwh has 655 (85.4%) zeros | Zeros |
pv_pct has 507 (66.1%) zeros | Zeros |
wind_pct has 663 (86.4%) zeros | Zeros |
nm_pct has 503 (65.6%) zeros | Zeros |
ee_pct has 467 (60.9%) zeros | Zeros |
dem_res_pct has 655 (85.4%) zeros | Zeros |
dem_res_cust_pct has 536 (69.9%) zeros | Zeros |
Reproduction
| Analysis started | 2020-11-29 16:15:33.924722 |
|---|---|
| Analysis finished | 2020-11-29 16:17:05.515726 |
| Duration | 1 minute and 31.59 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 722 |
|---|---|
| Distinct (%) | 94.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| PacifiCorp | 6 |
|---|---|
| Empire District Electric Co | 4 |
| Fall River Rural Elec Coop Inc | 3 |
| Southwestern Electric Power Co | 3 |
| Otter Tail Power Co | 3 |
| Other values (717) |
| Value | Count | Frequency (%) | |
| PacifiCorp | 6 | 0.8% | |
| Empire District Electric Co | 4 | 0.5% | |
| Fall River Rural Elec Coop Inc | 3 | 0.4% | |
| Southwestern Electric Power Co | 3 | 0.4% | |
| Otter Tail Power Co | 3 | 0.4% | |
| Black Hills Power, Inc. d/b/a | 3 | 0.4% | |
| Northern States Power Co - Minnesota | 3 | 0.4% | |
| MidAmerican Energy Co | 3 | 0.4% | |
| Southwestern Public Service Co | 2 | 0.3% | |
| Indiana Michigan Power Co | 2 | 0.3% | |
| Other values (712) | 735 | 95.8% |
Unique
| Unique | 689 ? |
|---|---|
| Unique (%) | 89.8% |
Length
| Max length | 40 |
|---|---|
| Median length | 27 |
| Mean length | 25.88787484 |
| Min length | 10 |
| Distinct | 51 |
|---|---|
| Distinct (%) | 6.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| MN | 50 |
|---|---|
| TX | 43 |
| TN | 37 |
| OH | 37 |
| NC | 32 |
| Other values (46) |
| Value | Count | Frequency (%) | |
| MN | 50 | 6.5% | |
| TX | 43 | 5.6% | |
| TN | 37 | 4.8% | |
| OH | 37 | 4.8% | |
| NC | 32 | 4.2% | |
| MO | 30 | 3.9% | |
| KY | 30 | 3.9% | |
| IN | 29 | 3.8% | |
| GA | 27 | 3.5% | |
| WI | 25 | 3.3% | |
| Other values (41) | 427 | 55.7% |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.4% |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
| Distinct | 767 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2877815.056 |
|---|---|
| Minimum | 2829 |
| Maximum | 111955723 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 2829 |
|---|---|
| 5-th percentile | 76915.6 |
| Q1 | 237437.5 |
| median | 531404 |
| Q3 | 1484748.5 |
| 95-th percentile | 13977822.2 |
| Maximum | 111955723 |
| Range | 111952894 |
| Interquartile range (IQR) | 1247311 |
Descriptive statistics
| Standard deviation | 8153766.99 |
|---|---|
| Coefficient of variation (CV) | 2.833318622 |
| Kurtosis | 65.29246089 |
| Mean | 2877815.056 |
| Median Absolute Deviation (MAD) | 374076 |
| Skewness | 6.847968817 |
| Sum | 2207284148 |
| Variance | 6.648391613e+13 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1165307 | 1 | 0.1% | |
| 115753 | 1 | 0.1% | |
| 909656 | 1 | 0.1% | |
| 771415 | 1 | 0.1% | |
| 176438 | 1 | 0.1% | |
| 422757 | 1 | 0.1% | |
| 849164 | 1 | 0.1% | |
| 864590 | 1 | 0.1% | |
| 2213172 | 1 | 0.1% | |
| 723276 | 1 | 0.1% | |
| Other values (757) | 757 | 98.7% |
| Value | Count | Frequency (%) | |
| 2829 | 1 | 0.1% | |
| 3294 | 1 | 0.1% | |
| 8831 | 1 | 0.1% | |
| 9809 | 1 | 0.1% | |
| 17010 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 111955723 | 1 | 0.1% | |
| 84700194 | 1 | 0.1% | |
| 62259607 | 1 | 0.1% | |
| 58505595 | 1 | 0.1% | |
| 56027201 | 1 | 0.1% |
| Distinct | 762 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 132509.8331 |
|---|---|
| Minimum | 41 |
| Maximum | 5061483 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 41 |
|---|---|
| 5-th percentile | 3207.8 |
| Q1 | 10953.5 |
| median | 24152 |
| Q3 | 65271.5 |
| 95-th percentile | 601167.3 |
| Maximum | 5061483 |
| Range | 5061442 |
| Interquartile range (IQR) | 54318 |
Descriptive statistics
| Standard deviation | 385328.9388 |
|---|---|
| Coefficient of variation (CV) | 2.907927131 |
| Kurtosis | 59.94885077 |
| Mean | 132509.8331 |
| Median Absolute Deviation (MAD) | 17403 |
| Skewness | 6.647667265 |
| Sum | 101635042 |
| Variance | 1.484783911e+11 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 10163 | 2 | 0.3% | |
| 14695 | 2 | 0.3% | |
| 13532 | 2 | 0.3% | |
| 22931 | 2 | 0.3% | |
| 12826 | 2 | 0.3% | |
| 19580 | 1 | 0.1% | |
| 24479 | 1 | 0.1% | |
| 249175 | 1 | 0.1% | |
| 447493 | 1 | 0.1% | |
| 27055 | 1 | 0.1% | |
| Other values (752) | 752 | 98.0% |
| Value | Count | Frequency (%) | |
| 41 | 1 | 0.1% | |
| 342 | 1 | 0.1% | |
| 357 | 1 | 0.1% | |
| 485 | 1 | 0.1% | |
| 499 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 5061483 | 1 | 0.1% | |
| 4120399 | 1 | 0.1% | |
| 2730588 | 1 | 0.1% | |
| 2635291 | 1 | 0.1% | |
| 2572624 | 1 | 0.1% |
no
Real number (ℝ≥0)
| Distinct | 722 |
|---|---|
| Distinct (%) | 94.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12300.2412 |
|---|---|
| Minimum | 97 |
| Maximum | 60839 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 97 |
|---|---|
| 5-th percentile | 1476.1 |
| Q1 | 5896 |
| median | 12268 |
| Q3 | 16715 |
| 95-th percentile | 21926.7 |
| Maximum | 60839 |
| Range | 60742 |
| Interquartile range (IQR) | 10819 |
Descriptive statistics
| Standard deviation | 8559.434421 |
|---|---|
| Coefficient of variation (CV) | 0.6958753314 |
| Kurtosis | 8.382814562 |
| Mean | 12300.2412 |
| Median Absolute Deviation (MAD) | 5430 |
| Skewness | 2.021330442 |
| Sum | 9434285 |
| Variance | 73263917.61 |
| Monotocity | Increasing |
| Value | Count | Frequency (%) | |
| 14354 | 6 | 0.8% | |
| 5860 | 4 | 0.5% | |
| 14232 | 3 | 0.4% | |
| 13781 | 3 | 0.4% | |
| 12341 | 3 | 0.4% | |
| 19545 | 3 | 0.4% | |
| 17698 | 3 | 0.4% | |
| 6169 | 3 | 0.4% | |
| 17718 | 2 | 0.3% | |
| 5027 | 2 | 0.3% | |
| Other values (712) | 735 | 95.8% |
| Value | Count | Frequency (%) | |
| 97 | 1 | 0.1% | |
| 108 | 1 | 0.1% | |
| 155 | 1 | 0.1% | |
| 162 | 1 | 0.1% | |
| 213 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 60839 | 1 | 0.1% | |
| 60631 | 1 | 0.1% | |
| 59013 | 1 | 0.1% | |
| 57483 | 1 | 0.1% | |
| 56697 | 1 | 0.1% |
type
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| Cooperative | |
|---|---|
| Municipal | |
| Investor Owned | |
| Political Subdivision | 21 |
| State | 2 |
| Value | Count | Frequency (%) | |
| Cooperative | 402 | 52.4% | |
| Municipal | 204 | 26.6% | |
| Investor Owned | 138 | 18.0% | |
| Political Subdivision | 21 | 2.7% | |
| State | 2 | 0.3% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 21 |
|---|---|
| Median length | 11 |
| Mean length | 11.26597132 |
| Min length | 5 |
saidi_nomed
Real number (ℝ≥0)
| Distinct | 753 |
|---|---|
| Distinct (%) | 98.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 138.7787744 |
|---|---|
| Minimum | 0.655 |
| Maximum | 1239.3 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0.655 |
|---|---|
| 5-th percentile | 11.6178 |
| Q1 | 55.63 |
| median | 99.8 |
| Q3 | 170.2595 |
| 95-th percentile | 395.214 |
| Maximum | 1239.3 |
| Range | 1238.645 |
| Interquartile range (IQR) | 114.6295 |
Descriptive statistics
| Standard deviation | 141.2249481 |
|---|---|
| Coefficient of variation (CV) | 1.017626425 |
| Kurtosis | 13.87560432 |
| Mean | 138.7787744 |
| Median Absolute Deviation (MAD) | 55.75 |
| Skewness | 3.002113658 |
| Sum | 106443.32 |
| Variance | 19944.48598 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 98 | 3 | 0.4% | |
| 104 | 3 | 0.4% | |
| 43.27 | 2 | 0.3% | |
| 201 | 2 | 0.3% | |
| 98.4 | 2 | 0.3% | |
| 160 | 2 | 0.3% | |
| 95.1 | 2 | 0.3% | |
| 61.56 | 2 | 0.3% | |
| 68.68 | 2 | 0.3% | |
| 96 | 2 | 0.3% | |
| Other values (743) | 745 | 97.1% |
| Value | Count | Frequency (%) | |
| 0.655 | 1 | 0.1% | |
| 1.394 | 1 | 0.1% | |
| 1.837 | 1 | 0.1% | |
| 2.2 | 1 | 0.1% | |
| 2.41 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 1239.3 | 1 | 0.1% | |
| 1225.3 | 1 | 0.1% | |
| 968.6 | 1 | 0.1% | |
| 909.71 | 1 | 0.1% | |
| 812.9 | 1 | 0.1% |
| Distinct | 542 |
|---|---|
| Distinct (%) | 70.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| . | 61 |
|---|---|
| 0.87 | 6 |
| 0.49 | 5 |
| 0.66 | 5 |
| 1.64 | 4 |
| Other values (537) |
| Value | Count | Frequency (%) | |
| . | 61 | 8.0% | |
| 0.87 | 6 | 0.8% | |
| 0.49 | 5 | 0.7% | |
| 0.66 | 5 | 0.7% | |
| 1.64 | 4 | 0.5% | |
| 0.94 | 4 | 0.5% | |
| 1.33 | 4 | 0.5% | |
| 1.03 | 4 | 0.5% | |
| 1.5 | 4 | 0.5% | |
| 1.12 | 4 | 0.5% | |
| Other values (532) | 666 | 86.8% |
Unique
| Unique | 429 ? |
|---|---|
| Unique (%) | 55.9% |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 4.235984355 |
| Min length | 1 |
| Distinct | 704 |
|---|---|
| Distinct (%) | 91.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| . | 61 |
|---|---|
| 100 | 2 |
| 75 | 2 |
| 80 | 2 |
| 98 | 1 |
| Other values (699) |
| Value | Count | Frequency (%) | |
| . | 61 | 8.0% | |
| 100 | 2 | 0.3% | |
| 75 | 2 | 0.3% | |
| 80 | 2 | 0.3% | |
| 98 | 1 | 0.1% | |
| 97.461538 | 1 | 0.1% | |
| 81.435897 | 1 | 0.1% | |
| 66.029668 | 1 | 0.1% | |
| 92.775264 | 1 | 0.1% | |
| 101.99177 | 1 | 0.1% | |
| Other values (694) | 694 | 90.5% |
Unique
| Unique | 700 ? |
|---|---|
| Unique (%) | 91.3% |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.062581486 |
| Min length | 1 |
| Distinct | 270 |
|---|---|
| Distinct (%) | 35.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 190.5423729 |
|---|---|
| Minimum | 1 |
| Maximum | 5619 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 30 |
| median | 57 |
| Q3 | 123 |
| 95-th percentile | 850.4 |
| Maximum | 5619 |
| Range | 5618 |
| Interquartile range (IQR) | 93 |
Descriptive statistics
| Standard deviation | 475.7502888 |
|---|---|
| Coefficient of variation (CV) | 2.496821477 |
| Kurtosis | 43.3178554 |
| Mean | 190.5423729 |
| Median Absolute Deviation (MAD) | 35 |
| Skewness | 5.799938951 |
| Sum | 146146 |
| Variance | 226338.3373 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 42 | 14 | 1.8% | |
| 16 | 12 | 1.6% | |
| 36 | 12 | 1.6% | |
| 30 | 12 | 1.6% | |
| 37 | 11 | 1.4% | |
| 43 | 11 | 1.4% | |
| 13 | 10 | 1.3% | |
| 41 | 9 | 1.2% | |
| 6 | 9 | 1.2% | |
| 8 | 9 | 1.2% | |
| Other values (260) | 658 | 85.8% |
| Value | Count | Frequency (%) | |
| 1 | 3 | 0.4% | |
| 2 | 1 | 0.1% | |
| 3 | 3 | 0.4% | |
| 4 | 5 | 0.7% | |
| 5 | 5 | 0.7% |
| Value | Count | Frequency (%) | |
| 5619 | 1 | 0.1% | |
| 4464 | 1 | 0.1% | |
| 3500 | 1 | 0.1% | |
| 3421 | 1 | 0.1% | |
| 3109 | 1 | 0.1% |
| Distinct | 141 |
|---|---|
| Distinct (%) | 18.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.01434159 |
|---|---|
| Minimum | 0 |
| Maximum | 2787 |
| Zeros | 473 |
| Zeros (%) | 61.7% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 19 |
| 95-th percentile | 167.7 |
| Maximum | 2787 |
| Range | 2787 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 205.1035109 |
|---|---|
| Coefficient of variation (CV) | 4.362573291 |
| Kurtosis | 88.89435487 |
| Mean | 47.01434159 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.609000658 |
| Sum | 36060 |
| Variance | 42067.45019 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 473 | 61.7% | |
| 4 | 16 | 2.1% | |
| 1 | 9 | 1.2% | |
| 14 | 8 | 1.0% | |
| 11 | 8 | 1.0% | |
| 22 | 6 | 0.8% | |
| 16 | 6 | 0.8% | |
| 6 | 6 | 0.8% | |
| 2 | 6 | 0.8% | |
| 9 | 6 | 0.8% | |
| Other values (131) | 223 | 29.1% |
| Value | Count | Frequency (%) | |
| 0 | 473 | 61.7% | |
| 1 | 9 | 1.2% | |
| 2 | 6 | 0.8% | |
| 3 | 5 | 0.7% | |
| 4 | 16 | 2.1% |
| Value | Count | Frequency (%) | |
| 2787 | 1 | 0.1% | |
| 2481 | 1 | 0.1% | |
| 2000 | 1 | 0.1% | |
| 1704 | 1 | 0.1% | |
| 1416 | 1 | 0.1% |
nerc
Categorical
| Distinct | 13 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| SERC | |
|---|---|
| RFC | |
| MRO | |
| WECC | |
| 0 | |
| Other values (8) |
| Value | Count | Frequency (%) | |
| SERC | 204 | 26.6% | |
| RFC | 127 | 16.6% | |
| MRO | 102 | 13.3% | |
| WECC | 101 | 13.2% | |
| 0 | 83 | 10.8% | |
| SPP | 59 | 7.7% | |
| NPCC | 30 | 3.9% | |
| TRE | 29 | 3.8% | |
| FRCC | 14 | 1.8% | |
| MISO | 9 | 1.2% | |
| Other values (3) | 9 | 1.2% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.1% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.241199478 |
| Min length | 1 |
| Distinct | 199 |
|---|---|
| Distinct (%) | 25.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1603899.498 |
|---|---|
| Minimum | -512 |
| Maximum | 126508512 |
| Zeros | 569 |
| Zeros (%) | 74.2% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | -512 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 46.5 |
| 95-th percentile | 9439026 |
| Maximum | 126508512 |
| Range | 126509024 |
| Interquartile range (IQR) | 46.5 |
Descriptive statistics
| Standard deviation | 8019806.349 |
|---|---|
| Coefficient of variation (CV) | 5.000192568 |
| Kurtosis | 103.6198706 |
| Mean | 1603899.498 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.836816232 |
| Sum | 1230190915 |
| Variance | 6.431729388e+13 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 569 | 74.2% | |
| 19080426 | 1 | 0.1% | |
| 25961 | 1 | 0.1% | |
| 270478 | 1 | 0.1% | |
| 21144343 | 1 | 0.1% | |
| 16027949 | 1 | 0.1% | |
| 126113 | 1 | 0.1% | |
| 794 | 1 | 0.1% | |
| 6576 | 1 | 0.1% | |
| 1626 | 1 | 0.1% | |
| Other values (189) | 189 | 24.6% |
| Value | Count | Frequency (%) | |
| -512 | 1 | 0.1% | |
| 0 | 569 | 74.2% | |
| 4 | 1 | 0.1% | |
| 21 | 1 | 0.1% | |
| 31 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 126508512 | 1 | 0.1% | |
| 84416930 | 1 | 0.1% | |
| 62612309 | 1 | 0.1% | |
| 60548978 | 1 | 0.1% | |
| 51747177 | 1 | 0.1% |
| Distinct | 683 |
|---|---|
| Distinct (%) | 89.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1562233.284 |
|---|---|
| Minimum | 0 |
| Maximum | 56679822 |
| Zeros | 85 |
| Zeros (%) | 11.1% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 159193 |
| median | 442563 |
| Q3 | 1078380 |
| 95-th percentile | 6722856.3 |
| Maximum | 56679822 |
| Range | 56679822 |
| Interquartile range (IQR) | 919187 |
Descriptive statistics
| Standard deviation | 4091160.083 |
|---|---|
| Coefficient of variation (CV) | 2.618789476 |
| Kurtosis | 65.33718524 |
| Mean | 1562233.284 |
| Median Absolute Deviation (MAD) | 342590 |
| Skewness | 6.847499692 |
| Sum | 1198232929 |
| Variance | 1.673759083e+13 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 85 | 11.1% | |
| 1225378 | 1 | 0.1% | |
| 50629 | 1 | 0.1% | |
| 820570 | 1 | 0.1% | |
| 502705 | 1 | 0.1% | |
| 226390 | 1 | 0.1% | |
| 58579 | 1 | 0.1% | |
| 387401 | 1 | 0.1% | |
| 2790733 | 1 | 0.1% | |
| 2587505 | 1 | 0.1% | |
| Other values (673) | 673 | 87.7% |
| Value | Count | Frequency (%) | |
| 0 | 85 | 11.1% | |
| 572 | 1 | 0.1% | |
| 3759 | 1 | 0.1% | |
| 18026 | 1 | 0.1% | |
| 19480 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 56679822 | 1 | 0.1% | |
| 42164686 | 1 | 0.1% | |
| 30230565 | 1 | 0.1% | |
| 29147341 | 1 | 0.1% | |
| 22675318 | 1 | 0.1% |
| Distinct | 51 |
|---|---|
| Distinct (%) | 6.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| 0 | |
|---|---|
| MISO | |
| PJM | |
| SWPP | |
| ERCO | |
| Other values (46) |
| Value | Count | Frequency (%) | |
| 0 | 191 | 24.9% | |
| MISO | 160 | 20.9% | |
| PJM | 82 | 10.7% | |
| SWPP | 60 | 7.8% | |
| ERCO | 29 | 3.8% | |
| SOCO | 28 | 3.7% | |
| BPAT | 25 | 3.3% | |
| ISNE | 22 | 2.9% | |
| AECI | 20 | 2.6% | |
| WACM | 15 | 2.0% | |
| Other values (41) | 135 | 17.6% |
Unique
| Unique | 20 ? |
|---|---|
| Unique (%) | 2.6% |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.050847458 |
| Min length | 1 |
| Distinct | 257 |
|---|---|
| Distinct (%) | 33.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1549.68204 |
|---|---|
| Minimum | 0 |
| Maximum | 466156.237 |
| Zeros | 507 |
| Zeros (%) | 66.1% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 55.9255 |
| 95-th percentile | 1890.7489 |
| Maximum | 466156.237 |
| Range | 466156.237 |
| Interquartile range (IQR) | 55.9255 |
Descriptive statistics
| Standard deviation | 18568.04635 |
|---|---|
| Coefficient of variation (CV) | 11.98184264 |
| Kurtosis | 522.559854 |
| Mean | 1549.68204 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 21.71589745 |
| Sum | 1188606.125 |
| Variance | 344772345.3 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 507 | 66.1% | |
| 9.167 | 2 | 0.3% | |
| 264.257 | 2 | 0.3% | |
| 0.26 | 2 | 0.3% | |
| 145 | 2 | 0.3% | |
| 215.722 | 1 | 0.1% | |
| 1253.27 | 1 | 0.1% | |
| 3725.46 | 1 | 0.1% | |
| 598.19 | 1 | 0.1% | |
| 16277 | 1 | 0.1% | |
| Other values (247) | 247 | 32.2% |
| Value | Count | Frequency (%) | |
| 0 | 507 | 66.1% | |
| 0.008 | 1 | 0.1% | |
| 0.01 | 1 | 0.1% | |
| 0.013 | 1 | 0.1% | |
| 0.038 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 466156.237 | 1 | 0.1% | |
| 169882.509 | 1 | 0.1% | |
| 86299.752 | 1 | 0.1% | |
| 71653.486 | 1 | 0.1% | |
| 47669 | 1 | 0.1% |
| Distinct | 103 |
|---|---|
| Distinct (%) | 13.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 85.94687353 |
|---|---|
| Minimum | 0 |
| Maximum | 49255.057 |
| Zeros | 663 |
| Zeros (%) | 86.4% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 14.3675 |
| Maximum | 49255.057 |
| Range | 49255.057 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1827.784027 |
|---|---|
| Coefficient of variation (CV) | 21.26643997 |
| Kurtosis | 688.1331473 |
| Mean | 85.94687353 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 25.81232179 |
| Sum | 65921.252 |
| Variance | 3340794.448 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 663 | 86.4% | |
| 26.707 | 2 | 0.3% | |
| 0.095 | 2 | 0.3% | |
| 0.26 | 1 | 0.1% | |
| 1474.704 | 1 | 0.1% | |
| 8.92 | 1 | 0.1% | |
| 0.822 | 1 | 0.1% | |
| 1.22 | 1 | 0.1% | |
| 0.08 | 1 | 0.1% | |
| 0.029 | 1 | 0.1% | |
| Other values (93) | 93 | 12.1% |
| Value | Count | Frequency (%) | |
| 0 | 663 | 86.4% | |
| 0.004 | 1 | 0.1% | |
| 0.02 | 1 | 0.1% | |
| 0.022 | 1 | 0.1% | |
| 0.026 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 49255.057 | 1 | 0.1% | |
| 11648.213 | 1 | 0.1% | |
| 1474.704 | 1 | 0.1% | |
| 625 | 1 | 0.1% | |
| 322.209 | 1 | 0.1% |
| Distinct | 261 |
|---|---|
| Distinct (%) | 34.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1643.192293 |
|---|---|
| Minimum | 0 |
| Maximum | 515411.294 |
| Zeros | 503 |
| Zeros (%) | 65.6% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 65.2265 |
| 95-th percentile | 1924.3 |
| Maximum | 515411.294 |
| Range | 515411.294 |
| Interquartile range (IQR) | 65.2265 |
Descriptive statistics
| Standard deviation | 20219.44585 |
|---|---|
| Coefficient of variation (CV) | 12.30497851 |
| Kurtosis | 552.4472018 |
| Mean | 1643.192293 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.41508526 |
| Sum | 1260328.489 |
| Variance | 408825990.6 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 503 | 65.6% | |
| 264.352 | 2 | 0.3% | |
| 0.26 | 2 | 0.3% | |
| 145 | 2 | 0.3% | |
| 35.874 | 2 | 0.3% | |
| 36556.823 | 1 | 0.1% | |
| 19412.845 | 1 | 0.1% | |
| 2493.99 | 1 | 0.1% | |
| 72242.219 | 1 | 0.1% | |
| 50.595 | 1 | 0.1% | |
| Other values (251) | 251 | 32.7% |
| Value | Count | Frequency (%) | |
| 0 | 503 | 65.6% | |
| 0.008 | 1 | 0.1% | |
| 0.01 | 1 | 0.1% | |
| 0.013 | 1 | 0.1% | |
| 0.038 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 515411.294 | 1 | 0.1% | |
| 169882.509 | 1 | 0.1% | |
| 86299.752 | 1 | 0.1% | |
| 72242.219 | 1 | 0.1% | |
| 47669 | 1 | 0.1% |
| Distinct | 300 |
|---|---|
| Distinct (%) | 39.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27549.04185 |
|---|---|
| Minimum | 0 |
| Maximum | 2097423 |
| Zeros | 467 |
| Zeros (%) | 60.9% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1209 |
| 95-th percentile | 165413.5943 |
| Maximum | 2097423 |
| Range | 2097423 |
| Interquartile range (IQR) | 1209 |
Descriptive statistics
| Standard deviation | 125573.9753 |
|---|---|
| Coefficient of variation (CV) | 4.55819756 |
| Kurtosis | 118.6923627 |
| Mean | 27549.04185 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.237865885 |
| Sum | 21130115.1 |
| Variance | 1.576882328e+10 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 467 | 60.9% | |
| 701 | 2 | 0.3% | |
| 343 | 1 | 0.1% | |
| 88.17 | 1 | 0.1% | |
| 722 | 1 | 0.1% | |
| 379 | 1 | 0.1% | |
| 197569.86 | 1 | 0.1% | |
| 10957.8 | 1 | 0.1% | |
| 8.382 | 1 | 0.1% | |
| 6189.046 | 1 | 0.1% | |
| Other values (290) | 290 | 37.8% |
| Value | Count | Frequency (%) | |
| 0 | 467 | 60.9% | |
| 0.002 | 1 | 0.1% | |
| 0.4 | 1 | 0.1% | |
| 1.309 | 1 | 0.1% | |
| 2.339 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 2097423 | 1 | 0.1% | |
| 1322045 | 1 | 0.1% | |
| 944608 | 1 | 0.1% | |
| 718196 | 1 | 0.1% | |
| 696831.73 | 1 | 0.1% |
| Distinct | 213 |
|---|---|
| Distinct (%) | 27.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12274.06258 |
|---|---|
| Minimum | 0 |
| Maximum | 895133 |
| Zeros | 536 |
| Zeros (%) | 69.9% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 31.5 |
| 95-th percentile | 36601.2 |
| Maximum | 895133 |
| Range | 895133 |
| Interquartile range (IQR) | 31.5 |
Descriptive statistics
| Standard deviation | 69746.80701 |
|---|---|
| Coefficient of variation (CV) | 5.682454896 |
| Kurtosis | 83.93998013 |
| Mean | 12274.06258 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.622895747 |
| Sum | 9414206 |
| Variance | 4864617087 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 536 | 69.9% | |
| 4 | 6 | 0.8% | |
| 1 | 5 | 0.7% | |
| 5 | 4 | 0.5% | |
| 2 | 3 | 0.4% | |
| 8 | 2 | 0.3% | |
| 19 | 2 | 0.3% | |
| 20 | 2 | 0.3% | |
| 27912 | 2 | 0.3% | |
| 629 | 2 | 0.3% | |
| Other values (203) | 203 | 26.5% |
| Value | Count | Frequency (%) | |
| 0 | 536 | 69.9% | |
| 1 | 5 | 0.7% | |
| 2 | 3 | 0.4% | |
| 4 | 6 | 0.8% | |
| 5 | 4 | 0.5% |
| Value | Count | Frequency (%) | |
| 895133 | 1 | 0.1% | |
| 758207 | 1 | 0.1% | |
| 724424 | 1 | 0.1% | |
| 693725 | 1 | 0.1% | |
| 485576 | 1 | 0.1% |
| Distinct | 110 |
|---|---|
| Distinct (%) | 14.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1751.307789 |
|---|---|
| Minimum | 0 |
| Maximum | 977215 |
| Zeros | 655 |
| Zeros (%) | 85.4% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 302.71 |
| Maximum | 977215 |
| Range | 977215 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 35827.02422 |
|---|---|
| Coefficient of variation (CV) | 20.45729737 |
| Kurtosis | 720.5853244 |
| Mean | 1751.307789 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 26.53946767 |
| Sum | 1343253.074 |
| Variance | 1283575664 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 655 | 85.4% | |
| 10 | 3 | 0.4% | |
| 47 | 2 | 0.3% | |
| 649.804 | 1 | 0.1% | |
| 744 | 1 | 0.1% | |
| 4.5 | 1 | 0.1% | |
| 134.64 | 1 | 0.1% | |
| 1.549 | 1 | 0.1% | |
| 140.882 | 1 | 0.1% | |
| 204.39 | 1 | 0.1% | |
| Other values (100) | 100 | 13.0% |
| Value | Count | Frequency (%) | |
| 0 | 655 | 85.4% | |
| 0.005 | 1 | 0.1% | |
| 0.1 | 1 | 0.1% | |
| 0.657 | 1 | 0.1% | |
| 0.689 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 977215 | 1 | 0.1% | |
| 162606 | 1 | 0.1% | |
| 33816.21 | 1 | 0.1% | |
| 31704 | 1 | 0.1% | |
| 28368 | 1 | 0.1% |
| Distinct | 261 |
|---|---|
| Distinct (%) | 34.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.06329298997 |
|---|---|
| Minimum | 0 |
| Maximum | 10.63045152 |
| Zeros | 507 |
| Zeros (%) | 66.1% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.007546905041 |
| 95-th percentile | 0.1597437484 |
| Maximum | 10.63045152 |
| Range | 10.63045152 |
| Interquartile range (IQR) | 0.007546905041 |
Descriptive statistics
| Standard deviation | 0.4962307468 |
|---|---|
| Coefficient of variation (CV) | 7.84021654 |
| Kurtosis | 325.1000385 |
| Mean | 0.06329298997 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.95503325 |
| Sum | 48.54572331 |
| Variance | 0.2462449541 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 507 | 66.1% | |
| 0.001021338813 | 1 | 0.1% | |
| 0.0102047939 | 1 | 0.1% | |
| 0.0003964357303 | 1 | 0.1% | |
| 0.03126919837 | 1 | 0.1% | |
| 0.1236176137 | 1 | 0.1% | |
| 0.02917009382 | 1 | 0.1% | |
| 0.2182504504 | 1 | 0.1% | |
| 0.0158576036 | 1 | 0.1% | |
| 0.3440268234 | 1 | 0.1% | |
| Other values (251) | 251 | 32.7% |
| Value | Count | Frequency (%) | |
| 0 | 507 | 66.1% | |
| 1.762774296e-07 | 1 | 0.1% | |
| 3.142061705e-06 | 1 | 0.1% | |
| 7.697710893e-06 | 1 | 0.1% | |
| 9.501479307e-06 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 10.63045152 | 1 | 0.1% | |
| 7.176059284 | 1 | 0.1% | |
| 2.646364893 | 1 | 0.1% | |
| 2.261200637 | 1 | 0.1% | |
| 2.163690212 | 1 | 0.1% |
| Distinct | 105 |
|---|---|
| Distinct (%) | 13.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.002523286726 |
|---|---|
| Minimum | 0 |
| Maximum | 0.7582376487 |
| Zeros | 663 |
| Zeros (%) | 86.4% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.002034468338 |
| Maximum | 0.7582376487 |
| Range | 0.7582376487 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.02955500793 |
|---|---|
| Coefficient of variation (CV) | 11.71290112 |
| Kurtosis | 562.9827451 |
| Mean | 0.002523286726 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.52253849 |
| Sum | 1.935360919 |
| Variance | 0.0008734984935 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 663 | 86.4% | |
| 0.01906694337 | 1 | 0.1% | |
| 0.02449443991 | 1 | 0.1% | |
| 0.001554286131 | 1 | 0.1% | |
| 0.001635752954 | 1 | 0.1% | |
| 0.001467158008 | 1 | 0.1% | |
| 0.0007332109353 | 1 | 0.1% | |
| 0.002870422957 | 1 | 0.1% | |
| 0.06987602028 | 1 | 0.1% | |
| 0.0003084318438 | 1 | 0.1% | |
| Other values (95) | 95 | 12.4% |
| Value | Count | Frequency (%) | |
| 0 | 663 | 86.4% | |
| 2.380995335e-07 | 1 | 0.1% | |
| 5.119760632e-07 | 1 | 0.1% | |
| 5.660150418e-07 | 1 | 0.1% | |
| 2.189482456e-06 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.7582376487 | 1 | 0.1% | |
| 0.199691357 | 1 | 0.1% | |
| 0.1419591758 | 1 | 0.1% | |
| 0.1006453523 | 1 | 0.1% | |
| 0.07294058208 | 1 | 0.1% |
| Distinct | 265 |
|---|---|
| Distinct (%) | 34.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.06694010457 |
|---|---|
| Minimum | 0 |
| Maximum | 10.63045152 |
| Zeros | 503 |
| Zeros (%) | 65.6% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.008334912244 |
| 95-th percentile | 0.172641644 |
| Maximum | 10.63045152 |
| Range | 10.63045152 |
| Interquartile range (IQR) | 0.008334912244 |
Descriptive statistics
| Standard deviation | 0.5122189637 |
|---|---|
| Coefficient of variation (CV) | 7.651899664 |
| Kurtosis | 309.9899077 |
| Mean | 0.06694010457 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.64730555 |
| Sum | 51.34306021 |
| Variance | 0.2623682668 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 503 | 65.6% | |
| 0.08400756486 | 1 | 0.1% | |
| 0.05928678936 | 1 | 0.1% | |
| 0.00816206858 | 1 | 0.1% | |
| 0.02638652561 | 1 | 0.1% | |
| 0.07671152452 | 1 | 0.1% | |
| 0.0004284791258 | 1 | 0.1% | |
| 0.002532720619 | 1 | 0.1% | |
| 0.0002954914819 | 1 | 0.1% | |
| 0.0102047939 | 1 | 0.1% | |
| Other values (255) | 255 | 33.2% |
| Value | Count | Frequency (%) | |
| 0 | 503 | 65.6% | |
| 1.762774296e-07 | 1 | 0.1% | |
| 3.142061705e-06 | 1 | 0.1% | |
| 7.697710893e-06 | 1 | 0.1% | |
| 9.501479307e-06 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 10.63045152 | 1 | 0.1% | |
| 7.934296933 | 1 | 0.1% | |
| 2.646402706 | 1 | 0.1% | |
| 2.261200637 | 1 | 0.1% | |
| 2.166459918 | 1 | 0.1% |
| Distinct | 301 |
|---|---|
| Distinct (%) | 39.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3685372872 |
|---|---|
| Minimum | 0 |
| Maximum | 10.72710265 |
| Zeros | 467 |
| Zeros (%) | 60.9% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.2373126344 |
| 95-th percentile | 1.683585311 |
| Maximum | 10.72710265 |
| Range | 10.72710265 |
| Interquartile range (IQR) | 0.2373126344 |
Descriptive statistics
| Standard deviation | 1.061427239 |
|---|---|
| Coefficient of variation (CV) | 2.880108136 |
| Kurtosis | 38.47378105 |
| Mean | 0.3685372872 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.537040118 |
| Sum | 282.6680993 |
| Variance | 1.126627785 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 467 | 60.9% | |
| 0.3439991099 | 1 | 0.1% | |
| 1.21642227 | 1 | 0.1% | |
| 3.805372691 | 1 | 0.1% | |
| 0.01801420716 | 1 | 0.1% | |
| 0.3609246412 | 1 | 0.1% | |
| 0.1267879989 | 1 | 0.1% | |
| 0.006993652289 | 1 | 0.1% | |
| 4.15724712 | 1 | 0.1% | |
| 0.9743961366 | 1 | 0.1% | |
| Other values (291) | 291 | 37.9% |
| Value | Count | Frequency (%) | |
| 0 | 467 | 60.9% | |
| 1.333502244e-06 | 1 | 0.1% | |
| 5.771817049e-05 | 1 | 0.1% | |
| 8.970168583e-05 | 1 | 0.1% | |
| 0.000111083541 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 10.72710265 | 1 | 0.1% | |
| 10.4402285 | 1 | 0.1% | |
| 8.150125129 | 1 | 0.1% | |
| 7.837453441 | 1 | 0.1% | |
| 7.81031793 | 1 | 0.1% |
| Distinct | 113 |
|---|---|
| Distinct (%) | 14.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.01813022599 |
|---|---|
| Minimum | 0 |
| Maximum | 3.50953437 |
| Zeros | 655 |
| Zeros (%) | 85.4% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.0097691566 |
| Maximum | 3.50953437 |
| Range | 3.50953437 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1799300655 |
|---|---|
| Coefficient of variation (CV) | 9.924314542 |
| Kurtosis | 252.2670477 |
| Mean | 0.01813022599 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 14.95854406 |
| Sum | 13.90588334 |
| Variance | 0.03237482847 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 655 | 85.4% | |
| 0.001280239954 | 1 | 0.1% | |
| 0.000755534516 | 1 | 0.1% | |
| 0.003374081524 | 1 | 0.1% | |
| 0.006763388058 | 1 | 0.1% | |
| 0.1136611693 | 1 | 0.1% | |
| 0.001412443343 | 1 | 0.1% | |
| 0.1709308033 | 1 | 0.1% | |
| 0.001180574099 | 1 | 0.1% | |
| 0.007025530779 | 1 | 0.1% | |
| Other values (103) | 103 | 13.4% |
| Value | Count | Frequency (%) | |
| 0 | 655 | 85.4% | |
| 7.320194073e-07 | 1 | 0.1% | |
| 3.664439909e-05 | 1 | 0.1% | |
| 4.458969131e-05 | 1 | 0.1% | |
| 6.927348433e-05 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 3.50953437 | 1 | 0.1% | |
| 2.649016084 | 1 | 0.1% | |
| 1.322372092 | 1 | 0.1% | |
| 1.298770351 | 1 | 0.1% | |
| 1.039468624 | 1 | 0.1% |
| Distinct | 230 |
|---|---|
| Distinct (%) | 30.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.560794711 |
|---|---|
| Minimum | 0 |
| Maximum | 100 |
| Zeros | 536 |
| Zeros (%) | 69.9% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.03561879445 |
| 95-th percentile | 31.608234 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 0.03561879445 |
Descriptive statistics
| Standard deviation | 13.82039082 |
|---|---|
| Coefficient of variation (CV) | 3.03025935 |
| Kurtosis | 21.52069424 |
| Mean | 4.560794711 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.351490243 |
| Sum | 3498.129543 |
| Variance | 191.0032023 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 536 | 69.9% | |
| 100 | 3 | 0.4% | |
| 7.90960452 | 1 | 0.1% | |
| 5.920503873 | 1 | 0.1% | |
| 25.6191849 | 1 | 0.1% | |
| 12.69281484 | 1 | 0.1% | |
| 2.550999716 | 1 | 0.1% | |
| 1.526235159 | 1 | 0.1% | |
| 3.277228667 | 1 | 0.1% | |
| 0.01601178467 | 1 | 0.1% | |
| Other values (220) | 220 | 28.7% |
| Value | Count | Frequency (%) | |
| 0 | 536 | 69.9% | |
| 0.0001876052935 | 1 | 0.1% | |
| 0.0002551039931 | 1 | 0.1% | |
| 0.0006884160236 | 1 | 0.1% | |
| 0.0006909078598 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 100 | 3 | 0.4% | |
| 99.99625741 | 1 | 0.1% | |
| 97.1412773 | 1 | 0.1% | |
| 85.5233853 | 1 | 0.1% | |
| 84.30358661 | 1 | 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| name | state | total_mwh | total_cust | no | type | saidi_nomed | saifi_nomed | caidi_nomed | circuits | voltage | nerc | gen_mwh | purchase_mwh | ba | pv_mwh | wind_mwh | nm_mwh | ee_mwh | dem_res_customers | dem_res_mwh | pv_pct | wind_pct | nm_pct | ee_pct | dem_res_pct | dem_res_cust_pct | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Adams Electric Coop | IL | 176102.0 | 8931.0 | 97.0 | Cooperative | 169.740 | 1.29 | 131.5814 | 47.0 | 47.0 | SERC | 4612.0 | 183534.0 | MISO | 0.000 | 0.000 | 0.000 | 0.0 | 4402.0 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 49.288993 |
| 1 | Adams-Columbia Electric Coop | WI | 515186.0 | 37607.0 | 108.0 | Cooperative | 139.900 | 0.95 | 147.26316 | 95.0 | 16.0 | MRO | 0.0 | 545904.0 | MISO | 705.775 | 22.235 | 728.010 | 0.0 | 4781.0 | 13647.36 | 0.136994 | 0.004316 | 0.141310 | 0.000000 | 2.649016 | 12.713059 |
| 2 | Agralite Electric Coop | MN | 238558.0 | 5251.0 | 155.0 | Cooperative | 128.759 | 1.181 | 109.0254 | 64.0 | 0.0 | MRO | 447.0 | 253275.0 | MISO | 0.000 | 0.000 | 0.000 | 0.0 | 0.0 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 |
| 3 | Aiken Electric Coop Inc | SC | 938436.0 | 48059.0 | 162.0 | Cooperative | 97.720 | . | . | 122.0 | 0.0 | SERC | 0.0 | 980124.0 | SC | 354.456 | 0.000 | 354.456 | 3.8 | 0.0 | 0.00 | 0.037771 | 0.000000 | 0.037771 | 0.000405 | 0.000000 | 0.000000 |
| 4 | Alaska Electric Light&Power Co | AK | 337796.0 | 17280.0 | 213.0 | Investor Owned | 79.000 | 2.08 | 37.980769 | 31.0 | 31.0 | AK | 123203.0 | 235572.0 | 0 | 0.000 | 0.000 | 0.000 | 0.0 | 2386.0 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 13.807870 |
| 5 | City of Albemarle - (NC) | NC | 282568.0 | 12072.0 | 232.0 | Municipal | 44.050 | 0.53 | 83.113208 | 14.0 | 14.0 | SERC | 0.0 | 293574.0 | 0 | 0.000 | 0.000 | 0.000 | 0.0 | 0.0 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 |
| 6 | Albertville Municipal Utilities Board | AL | 604222.0 | 10277.0 | 241.0 | Municipal | 21.624 | 0.418 | 51.732057 | 22.0 | 0.0 | SERC | 0.0 | 623425.0 | 0 | 0.000 | 0.000 | 0.000 | 0.0 | 0.0 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 |
| 7 | Alger-Delta Coop Electric Assn | MI | 75981.0 | 10089.0 | 305.0 | Cooperative | 55.852 | 0.117 | 477.36752 | 17.0 | 0.0 | MISO | 0.0 | 85152.0 | MISO | 0.000 | 0.000 | 0.000 | 0.0 | 0.0 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 |
| 8 | Allamakee-Clayton El Coop, Inc | IA | 133395.0 | 9987.0 | 329.0 | Cooperative | 141.600 | 0.965 | 146.73575 | 53.0 | 0.0 | MRO | 148.0 | 150540.0 | MISO | 1035.749 | 0.144 | 1035.893 | 1124.0 | 2768.0 | 0.00 | 0.776453 | 0.000108 | 0.776561 | 0.842610 | 0.000000 | 27.716031 |
| 9 | Altamaha Electric Member Corp | GA | 440677.0 | 20790.0 | 407.0 | Cooperative | 95.100 | 0.47 | 202.34043 | 57.0 | 57.0 | SERC | 0.0 | 451195.0 | SOCO | 0.000 | 0.000 | 0.000 | 0.0 | 256.0 | 14.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.003177 | 1.231361 |
Last rows
| name | state | total_mwh | total_cust | no | type | saidi_nomed | saifi_nomed | caidi_nomed | circuits | voltage | nerc | gen_mwh | purchase_mwh | ba | pv_mwh | wind_mwh | nm_mwh | ee_mwh | dem_res_customers | dem_res_mwh | pv_pct | wind_pct | nm_pct | ee_pct | dem_res_pct | dem_res_cust_pct | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 757 | Southwest Iowa Rural Elec Coop | IA | 108165.0 | 5915.0 | 49986.0 | Cooperative | 121.760 | 1.687 | 72.175459 | 16.0 | 0.0 | RFC | 0.0 | 118904.0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.0 | 0.000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 |
| 758 | NSTAR Electric Company | MA | 6495992.0 | 696258.0 | 54913.0 | Investor Owned | 70.300 | 0.735 | 95.646259 | 2259.0 | 524.0 | 0 | 0.0 | 0.0 | ISNE | 466156.237 | 49255.057 | 515411.294 | 696831.730 | 8079.0 | 4.500 | 7.176059 | 0.758238 | 7.934297 | 10.727103 | 0.000069 | 1.160346 |
| 759 | Entergy Texas Inc. | TX | 19008103.0 | 459190.0 | 55937.0 | Investor Owned | 297.000 | 2.019 | 147.10253 | 671.0 | 0.0 | SERC | 6326958.0 | 15088727.0 | MISO | 0.000 | 0.000 | 0.000 | 44488.239 | 8.0 | 73.753 | 0.000000 | 0.000000 | 0.000000 | 0.234049 | 0.000388 | 0.001742 |
| 760 | Heart of Texas Electric Coop | TX | 474367.0 | 22155.0 | 55982.0 | Cooperative | 167.150 | 1.33 | 125.67669 | 61.0 | 0.0 | 0 | 0.0 | 0.0 | ERCO | 0.000 | 0.000 | 0.000 | 0.000 | 0.0 | 0.000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 |
| 761 | Black Hills Colorado Electric, LLC | CO | 1954358.0 | 97890.0 | 56146.0 | Investor Owned | 73.669 | 1.307 | 56.364958 | 127.0 | 0.0 | 0 | 0.0 | 0.0 | PSCO | 0.000 | 0.000 | 0.000 | 15726.000 | 0.0 | 0.000 | 0.000000 | 0.000000 | 0.000000 | 0.804663 | 0.000000 | 0.000000 |
| 762 | Ameren Illinois Company | IL | 8017902.0 | 499059.0 | 56697.0 | Investor Owned | 132.290 | 0.995 | 132.95477 | 2966.0 | 0.0 | 0 | 0.0 | 0.0 | MISO | 0.000 | 0.000 | 0.000 | 333324.000 | 0.0 | 0.000 | 0.000000 | 0.000000 | 0.000000 | 4.157247 | 0.000000 | 0.000000 |
| 763 | Liberty Utilities | CA | 564462.0 | 48770.0 | 57483.0 | Investor Owned | 416.510 | 2.96 | 140.71284 | 42.0 | 0.0 | WECC | 131026.0 | 456184.0 | CISO | 0.000 | 0.000 | 0.000 | 1779.139 | 0.0 | 0.000 | 0.000000 | 0.000000 | 0.000000 | 0.315192 | 0.000000 | 0.000000 |
| 764 | PUD No 1 of Jefferson County | WA | 376212.0 | 19742.0 | 59013.0 | Political Subdivision | 291.000 | 2.04 | 142.64706 | 21.0 | 21.0 | 0 | 0.0 | 0.0 | BPAT | 0.000 | 0.000 | 0.000 | 651.000 | 0.0 | 0.000 | 0.000000 | 0.000000 | 0.000000 | 0.173041 | 0.000000 | 0.000000 |
| 765 | Upper Michigan Energy Resources Corp. | MI | 1610240.0 | 36818.0 | 60631.0 | Investor Owned | 238.000 | 1.5 | 158.66667 | 57.0 | 0.0 | 0 | 0.0 | 0.0 | MISO | 0.000 | 0.000 | 0.000 | 0.000 | 80.0 | 0.000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.217285 |
| 766 | Southern Pioneer Electric Company | KS | 817910.0 | 16939.0 | 60839.0 | Cooperative | 106.410 | . | . | 83.0 | 0.0 | 0 | 0.0 | 0.0 | SWPP | 41.042 | 0.000 | 41.042 | 0.000 | 0.0 | 0.000 | 0.005018 | 0.000000 | 0.005018 | 0.000000 | 0.000000 | 0.000000 |